package manager.point;
import java.io.*;
import common.db.*;
import common.main.*;

public class PointInfoBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String id = (String)inputTable.get("id");

		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT ID, POINT_VALUE,EXPERATION_DATE,TO_CHAR(POINT_START_DATE, 'YYYY-MM-DD') POINT_START_DATE,USEYN,REG_ID,");
		queryBuffer.append("TO_CHAR(REG_DATE, 'YYYY-MM-DD AM HH:MI:SS') REG_DATE,REG_IP, UPD_ID, TO_CHAR(UPD_DATE, 'YYYY-MM-DD AM HH:MI:SS') UPD_DATE, UPD_IP ");
		queryBuffer.append("FROM POINT WHERE ID='"+id+"'");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}